use "data_for_lent.dta"

eststo clear

********************
**** table 5 *******
********************


eststo: reghdfe log_meanLent lag_log_meanLent   log_totalETF  ///
						 ///
				if DataDate>=mdy(12,1,2010) &  DataDate<=mdy(12,31,2019) & meanLent<=1  ///
					 , ///
a(QUICK dateq) vce(cluster QUICK dateq)



eststo: reghdfe log_meanLent lag_log_meanLent   c.log_totalETF c.log_totalETF#i.lagq_flag_high  ///
					lagq_frate_stock lagq_log_turnover lagq_log_marketcap lagq_DIVY lagq_flag_high lagq_log_per lagq_log_vola ///
						c.lagq_frate_stock#i.lagq_flag_high c.lagq_log_turnover#i.lagq_flag_high ///
							c.lagq_log_marketcap#i.lagq_flag_high ///
							c.lagq_DIVY#i.lagq_flag_high  c.lagq_log_vola#i.lagq_flag_high  ///
							lagq_flag_high ///
							c.lagq_log_per#i.lagq_flag_high ///
					if DataDate>=mdy(12,1,2010) &  DataDate<=mdy(12,31,2019) & meanLent<=1  ///
					 , ///
a(QUICK dateq) vce(cluster QUICK dateq)





eststo: reghdfe log_2meanLent lag_log_meanLent c.log_2totalETF  ///
					if DataDate>=mdy(12,1,2010) &  DataDate<=mdy(12,31,2019) & meanLent<=1  ///
					 , ///
a(QUICK dateq) vce(cluster QUICK dateq)







eststo: reghdfe log_2meanLent lag_log_meanLent  c.log_2totalETF   c.log_2totalETF#i.lagq_flag_high  ///
					lagq_frate_stock lagq_log_turnover lagq_log_marketcap lagq_DIVY lagq_flag_high lagq_log_per c.lagq_log_vola ///
						c.lagq_frate_stock#i.lagq_flag_high c.lagq_log_turnover#i.lagq_flag_high ///
							c.lagq_log_marketcap#i.lagq_flag_high ///
							c.lagq_DIVY#i.lagq_flag_high ///
							lagq_flag_high c.lagq_log_vola#i.lagq_flag_high  ///
							c.lagq_log_per#i.lagq_flag_high ///
					if DataDate>=mdy(12,1,2010) &  DataDate<=mdy(12,31,2019) & meanLent<=1  ///
					 , ///
a(QUICK dateq) vce(cluster QUICK dateq)





****3quarters

eststo: reghdfe log_3meanLent lag_log_meanLent  c.log_3totalETF ///
					if DataDate>=mdy(12,1,2010) &  DataDate<=mdy(12,31,2019) & meanLent<=1  ///
					 , ///
a(QUICK dateq) vce(cluster QUICK dateq)
	

	
****3quarters

eststo: reghdfe log_3meanLent lag_log_meanLent  c.log_3totalETF c.log_3totalETF#i.lagq_flag_high  ///
					lagq_frate_stock lagq_log_turnover lagq_log_marketcap lagq_DIVY lagq_flag_high lagq_log_per ///
						c.lagq_frate_stock#i.lagq_flag_high c.lagq_log_turnover#i.lagq_flag_high c.lagq_log_vola ///
							c.lagq_log_marketcap#i.lagq_flag_high ///
							c.lagq_DIVY#i.lagq_flag_high ///
							lagq_flag_high ///
							c.lagq_log_per#i.lagq_flag_high c.lagq_log_vola#i.lagq_flag_high ///
					if DataDate>=mdy(12,1,2010) &  DataDate<=mdy(12,31,2019) & meanLent<=1  ///
					 , ///
a(QUICK dateq) vce(cluster QUICK dateq)
	

****4quarters

eststo: reghdfe log_4meanLent lag_log_meanLent  c.log_4totalETF ///
					if DataDate>=mdy(12,1,2010) &  DataDate<=mdy(12,31,2019) & meanLent<=1  ///
					 , ///
a(QUICK dateq) vce(cluster QUICK dateq)
	
	
	
****4quarters

eststo: reghdfe log_4meanLent lag_log_meanLent  c.log_4totalETF c.log_4totalETF#i.lagq_flag_high  ///
					lagq_frate_stock lagq_log_turnover lagq_log_marketcap lagq_DIVY lagq_flag_high lagq_log_per ///
						c.lagq_frate_stock#i.lagq_flag_high c.lagq_log_turnover#i.lagq_flag_high c.lagq_log_vola ///
							c.lagq_log_marketcap#i.lagq_flag_high ///
							c.lagq_DIVY#i.lagq_flag_high ///
							lagq_flag_high ///
							c.lagq_log_per#i.lagq_flag_high c.lagq_log_vola#i.lagq_flag_high  ///
					if DataDate>=mdy(12,1,2010) &  DataDate<=mdy(12,31,2019) & meanLent<=1  ///
					 , ///
a(QUICK dateq) vce(cluster QUICK dateq)
	
	
	
	


****5quarters
eststo: reghdfe log_5meanLent lag_log_meanLent  c.log_5totalETF  ///
					if DataDate>=mdy(12,1,2010) &  DataDate<=mdy(12,31,2019) & meanLent<=1  ///
					 , ///
a(QUICK dateq) vce(cluster QUICK dateq)
	
	
	
eststo: reghdfe log_5meanLent lag_log_meanLent  c.log_5totalETF c.log_5totalETF#i.lagq_flag_high  ///
					lagq_frate_stock lagq_log_turnover lagq_log_marketcap lagq_DIVY lagq_flag_high lagq_log_per ///
						c.lagq_frate_stock#i.lagq_flag_high c.lagq_log_turnover#i.lagq_flag_high c.lagq_log_vola ///
							c.lagq_log_marketcap#i.lagq_flag_high ///
							c.lagq_DIVY#i.lagq_flag_high ///
							lagq_flag_high ///
							c.lagq_log_per#i.lagq_flag_high c.lagq_log_vola#i.lagq_flag_high ///
					if DataDate>=mdy(12,1,2010) &  DataDate<=mdy(12,31,2019) & meanLent<=1  ///
					 , ///
a(QUICK dateq) vce(cluster QUICK dateq)


****************************
********** Table A4 *********
****************************		




eststo: reghdfe log_meanLent lag_log_meanLent log_totalETF  Share_PensionTrusts c.log_totalETF#c.Share_PensionTrusts ///
						 ///
				if DataDate>=mdy(12,1,2010) &  DataDate<=mdy(12,31,2019) & meanLent<=1  ///
					 , ///
a(QUICK dateq) vce(cluster QUICK dateq)





eststo: reghdfe log_meanLent lag_log_meanLent c.log_totalETF Share_PensionTrusts c.log_totalETF#c.Share_PensionTrusts c.log_totalETF#i.lagq_flag_high  ///
					lagq_frate_stock lagq_log_turnover lagq_log_marketcap lagq_DIVY lagq_flag_high lagq_log_per lagq_log_vola ///
						c.lagq_frate_stock#i.lagq_flag_high c.lagq_log_turnover#i.lagq_flag_high ///
							c.lagq_log_marketcap#i.lagq_flag_high ///
							c.lagq_DIVY#i.lagq_flag_high ///
							lagq_flag_high ///
							c.lagq_log_per#i.lagq_flag_high c.lagq_log_vola#i.lagq_flag_high Share_PensionTrusts ///
					if DataDate>=mdy(12,1,2010) &  DataDate<=mdy(12,31,2019) & meanLent<=1  ///
					 , ///
a(QUICK dateq) vce(cluster QUICK dateq)



eststo: reghdfe log_2meanLent lag_log_meanLent c.log_2totalETF Share_PensionTrusts c.log2_totalETF#c.Share_PensionTrusts /// 
 ///
					if DataDate>=mdy(12,1,2010) &  DataDate<=mdy(12,31,2019) & meanLent<=1  ///
					 , ///
a(QUICK dateq) vce(cluster QUICK dateq)


eststo: reghdfe log_2meanLent lag_log_meanLent c.log_2totalETF c.log2_totalETF#c.Share_PensionTrusts  c.log_2totalETF#i.lagq_flag_high  ///
					lagq_frate_stock lagq_log_turnover lagq_log_marketcap lagq_DIVY lagq_flag_high lagq_log_per lagq_log_vola ///
						c.lagq_frate_stock#i.lagq_flag_high c.lagq_log_turnover#i.lagq_flag_high ///
							c.lagq_log_marketcap#i.lagq_flag_high ///
							c.lagq_DIVY#i.lagq_flag_high ///
							lagq_flag_high ///
							c.lagq_log_per#i.lagq_flag_high c.lagq_log_vola#i.lagq_flag_high Share_PensionTrusts ///
					if DataDate>=mdy(12,1,2010) &  DataDate<=mdy(12,31,2019) & meanLent<=1  ///
					 , ///
a(QUICK dateq) vce(cluster QUICK dateq)



	
eststo: reghdfe log_3meanLent lag_log_meanLent c.log_3totalETF Share_PensionTrusts c.log3_totalETF#c.Share_PensionTrusts ///
					if DataDate>=mdy(12,1,2010) &  DataDate<=mdy(12,31,2019) & meanLent<=1  ///
					 , ///
a(QUICK dateq) vce(cluster QUICK dateq)
	
	

	
eststo: reghdfe log_3meanLent lag_log_meanLent c.log_3totalETF c.log3_totalETF#c.Share_PensionTrusts c.log_3totalETF#i.lagq_flag_high  ///
					lagq_frate_stock lagq_log_turnover lagq_log_marketcap lagq_DIVY lagq_flag_high lagq_log_per lagq_log_vola ///
						c.lagq_frate_stock#i.lagq_flag_high c.lagq_log_turnover#i.lagq_flag_high ///
							c.lagq_log_marketcap#i.lagq_flag_high ///
							c.lagq_DIVY#i.lagq_flag_high ///
							lagq_flag_high ///
							c.lagq_log_per#i.lagq_flag_high c.lagq_log_vola#i.lagq_flag_high Share_PensionTrusts ///
					if DataDate>=mdy(12,1,2010) &  DataDate<=mdy(12,31,2019) & meanLent<=1  ///
					 , ///
a(QUICK dateq) vce(cluster QUICK dateq)



****4quarters

eststo: reghdfe log_4meanLent lag_log_meanLent c.log_4totalETF  Share_PensionTrusts c.log4_totalETF#c.Share_PensionTrusts ///
					if DataDate>=mdy(12,1,2010) &  DataDate<=mdy(12,31,2019) & meanLent<=1  ///
					 , ///
a(QUICK dateq) vce(cluster QUICK dateq)
	
	
	
****4quarters

eststo: reghdfe log_4meanLent lag_log_meanLent c.log_4totalETF c.log4_totalETF#c.Share_PensionTrusts c.log_4totalETF#i.lagq_flag_high  ///
					lagq_frate_stock lagq_log_turnover lagq_log_marketcap lagq_DIVY lagq_flag_high lagq_log_per lagq_log_vola ///
						c.lagq_frate_stock#i.lagq_flag_high c.lagq_log_turnover#i.lagq_flag_high ///
							c.lagq_log_marketcap#i.lagq_flag_high ///
							c.lagq_DIVY#i.lagq_flag_high ///
							lagq_flag_high ///
							c.lagq_log_per#i.lagq_flag_high c.lagq_log_vola#i.lagq_flag_high Share_PensionTrusts  ///
					if DataDate>=mdy(12,1,2010) &  DataDate<=mdy(12,31,2019) & meanLent<=1  ///
					 , ///
a(QUICK dateq) vce(cluster QUICK dateq)
	
	


****5quarters
eststo: reghdfe log_5meanLent lag_log_meanLent c.log_5totalETF Share_PensionTrusts c.log5_totalETF#c.Share_PensionTrusts /// c.log_5totalETF#i.lagq_flag_high  ///
						 ///
					if DataDate>=mdy(12,1,2010) &  DataDate<=mdy(12,31,2019) & meanLent<=1  ///
					 , ///
a(QUICK dateq) vce(cluster QUICK dateq)
	
	
	
eststo: reghdfe log_5meanLent lag_log_meanLent c.log_5totalETF c.log5_totalETF#c.Share_PensionTrusts c.log_5totalETF#i.lagq_flag_high  ///
					lagq_frate_stock lagq_log_turnover lagq_log_marketcap lagq_DIVY lagq_flag_high lagq_log_per lagq_log_vola ///
						c.lagq_frate_stock#i.lagq_flag_high c.lagq_log_turnover#i.lagq_flag_high ///
							c.lagq_log_marketcap#i.lagq_flag_high ///
							c.lagq_DIVY#i.lagq_flag_high ///
							lagq_flag_high ///
							c.lagq_log_per#i.lagq_flag_high c.lagq_log_vola#i.lagq_flag_high Share_PensionTrusts ///
					if DataDate>=mdy(12,1,2010) &  DataDate<=mdy(12,31,2019) & meanLent<=1  ///
					 , ///
a(QUICK dateq) vce(cluster QUICK dateq)
		
	
